CREATE TABLE [dbo].[City]
(
[CityId] [int] NOT NULL,
[RegionId] [int] NOT NULL,
[Name] [nvarchar] (128) COLLATE Cyrillic_General_CI_AS NOT NULL,
[IsVisible] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[City] ADD CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED  ([CityId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[City] ADD CONSTRAINT [FK_City_Region] FOREIGN KEY ([RegionId]) REFERENCES [dbo].[Region] ([RegionId])
GO
